<?php
/*
	Copyright 2006, 2007, 2008, 2009, 2010 Bastiaan Grutters
    
    This file is part of Ages of Strife website.

    Ages of Strife website is free software: you can redistribute it and/or modify
    it under the terms of the GNU General Public License as published by
    the Free Software Foundation, either version 3 of the License, or
    (at your option) any later version.

    Ages of Strife website is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU General Public License for more details.

    You should have received a copy of the GNU General Public License
    along with Ages of Strife website.  If not, see <http://www.gnu.org/licenses/>.
 */
include( '../global/initialize.php' );

if( isset( $_POST[ 'name' ] ) && ( ( isset( $_POST[ 'turns' ] ) && is_numeric( $_POST[ 'turns' ] ) ) || isset( $_POST[ 'unban' ] ) ) ) {
    $query = "SELECT count(*) FROM ruler WHERE name = '" . addslashes( $_POST[ 'name' ] ) . "'";
    $result = mysql_query( $query ) or die( "Query failed : " . mysql_error() );
	$row = mysql_fetch_array( $result, MYSQL_ASSOC );
	if( $row[ 'count(*)' ] > 0 ) {
	    $query = "SELECT ruler_id FROM ruler WHERE name = '" . addslashes( $_POST[ 'name' ] ) . "'";
	    $result = mysql_query( $query ) or die( "Query failed : " . mysql_error() );
		$row = mysql_fetch_array( $result, MYSQL_ASSOC );
	    
	    if( isset( $_POST[ 'unban' ] ) ) {
		    $query2 = "SELECT users.user_id FROM users JOIN ruler ON users.user_id = ruler.user_id WHERE ruler_id = " . $row[ 'ruler_id' ];
		    $result2 = mysql_query( $query2 ) or die( "Query failed : " . mysql_error() );
			$row2 = mysql_fetch_array( $result2, MYSQL_ASSOC );
			$query2 = "UPDATE users SET banned = 0 WHERE user_id = " . $row2[ 'user_id' ];
	    	mysql_query( $query2 ) or die( "Query failed : " . mysql_error() );

			$query2 = "UPDATE ruler SET ban_turn = -1 WHERE ruler_id = " . $row[ 'ruler_id' ];
	    	mysql_query( $query2 ) or die( "Query failed : " . mysql_error() );

			$_SESSION[ 'ban_ruler_status' ] = $_POST[ 'name' ] . " unbanned.";
			header( "Location: rulers.php" );
	    }
	    else {
		    $query2 = "SELECT turn FROM game";
		    $result2 = mysql_query( $query2 ) or die( "Query failed : " . mysql_error() );
			$row2 = mysql_fetch_array( $result2, MYSQL_ASSOC );
			if( $_POST[ 'turns' ] == 0 ) {
			    $query2 = "SELECT users.user_id FROM users JOIN ruler ON users.user_id = ruler.user_id WHERE ruler_id = " . $row[ 'ruler_id' ];
			    $result2 = mysql_query( $query2 ) or die( "Query failed : " . mysql_error() );
				$row2 = mysql_fetch_array( $result2, MYSQL_ASSOC );
				$query2 = "UPDATE users SET banned = 1 WHERE user_id = " . $row2[ 'user_id' ];
		    	mysql_query( $query2 ) or die( "Query failed : " . mysql_error() );
				$_SESSION[ 'ban_ruler_status' ] = $_POST[ 'name' ] . " permanently banned!";
				header( "Location: rulers.php" );
			}
			else {
				$banned_till = $row2[ 'turn' ] + $_POST[ 'turns' ];
				$query2 = "UPDATE ruler SET ban_turn = $banned_till WHERE ruler_id = " . $row[ 'ruler_id' ];
		    	mysql_query( $query2 ) or die( "Query failed : " . mysql_error() );
				$_SESSION[ 'ban_ruler_status' ] = $_POST[ 'name' ] . " banned until turn: " . number_format( $banned_till ) . ".";
				header( "Location: rulers.php" );
			}
	    }
	}
	else {
		$_SESSION[ 'ban_ruler_status' ] = $_POST[ 'name' ] . " doesn't exist!";
		header( "Location: rulers.php" );
	}
}
else {
	$_SESSION[ 'ban_ruler_status' ] = "Weirdness error!";
	header( "Location: rulers.php" );
}
?>
